

from common.setting import ensure_path_sep
from utils.mysqlUtils.db_pool import Database

zhcxkj_center_strategy_comprehensive_db= Database(ensure_path_sep("\\config\\shopeev2_config.yaml.bak"), "test_jdw_database")




class T_publish_detail_allegro:


    @staticmethod
    def filter_t_publish_detail_allegro_sku(source_id_set,sku):
        get_list = f"""
        select source_id,sku,ean
        from test_zhcxkj_center_strategy_comprehensive.t_publish_detail_allegro
        where sku =%s
        and source_id in %s
        and status in (0,1,2,6)
        """
        data = zhcxkj_center_strategy_comprehensive_db.fetch_all_tuple(get_list, (sku,source_id_set))
        return data





